Tabela CO_DISH

Definicja tabeli CO_DISH

Name

CO_DISH

Code

CO_DISH

Comment

 


Lista kolumn tabeli CO_DISH

Name

Code

CO_DISHID

CO_DISHID

NAME

NAME

ACTIVE

ACTIVE

INSERTDATE

INSERTDATE

INSERTINGPERSON

INSERTINGPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT

ExternalId

ExternalId


Kolumna CO_DISHID tabeli CO_DISH

Definicja kolumny CO_DISHID tabeli CO_DISH

Name

CO_DISHID

Code

CO_DISHID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna NAME tabeli CO_DISH

Definicja kolumny NAME tabeli CO_DISH

Name

NAME

Code

NAME

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna ACTIVE tabeli CO_DISH

Definicja kolumny ACTIVE tabeli CO_DISH

Name

ACTIVE

Code

ACTIVE

Data Type

NUMBER(5)

Mandatory

Yes

Comment

 


Kolumna INSERTDATE tabeli CO_DISH

Definicja kolumny INSERTDATE tabeli CO_DISH

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna INSERTINGPERSON tabeli CO_DISH

Definicja kolumny INSERTINGPERSON tabeli CO_DISH

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CO_DISH

Definicja kolumny LASTMODIFIEDPERSON tabeli CO_DISH

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CO_DISH

Definicja kolumny LASTMODIFIEDDT tabeli CO_DISH

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ExternalId tabeli CO_DISH

Definicja kolumny ExternalId tabeli CO_DISH

Name

ExternalId

Code

ExternalId

Data Type

NUMBER(10)

Mandatory

No

Comment

StockItemId w module Pharmacy


Lista kluczy tabeli CO_DISH

Name

Code

Primary

PK_CO_DISH

PK_CO_DISH

X


Klucz PK_CO_DISH tabeli CO_DISH

Definicja klucza PK_CO_DISH tabeli CO_DISH

Name

PK_CO_DISH

Code

PK_CO_DISH

Primary

Yes

Comment